Database Auditing Design on Historical Data

Database Auditing is one of the major issues in information security. Lack of data auditing leads the business applications to the lost trail of business processes. To cope with auditing, historical data or temporal database is needed in order to track operations and actors of the operation with the time. Valid and transaction times are two major timestamps in temporal database. In this paper, we demonstrate the techniques to handle database auditing in business transaction by considering operations, valid times, and actors of the operations. These techniques are divided in two sets; using relational databases, and using semi-